UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6tW0fVcBpb8pdcshYcbBZbEtXzJIC1AkvqHvts0kCPs='
WHERE
key_id = '0f3bbf6d9dd39f92641ec625d15a618aac595853cdb32e7d3c814eed586a313c'
AND (
token = '6tW0fVcBpb8pdcshYcbBZbEtXzJIC1AkvqHvts0kCPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)