UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BH+MKG6dSqjFtmhf1NEPmLA+PKuYSkjWeXFIYS3lvAQ='
WHERE
key_id = '8e29b7b8ce34c8f64d1deca11d4ac08c4173a16da9e54b33675023372784398f'
AND (
token = 'BH+MKG6dSqjFtmhf1NEPmLA+PKuYSkjWeXFIYS3lvAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)