UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BNeNqjuFhLyNDa8qMJcKQOrtApOQBpyBVo6KYM9Yfv8='
WHERE
key_id = '86e4c1e805a49e85a418784c895357b437d208748c68e47b3b809441b7009a43'
AND (
token = 'BNeNqjuFhLyNDa8qMJcKQOrtApOQBpyBVo6KYM9Yfv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)