UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXdKlwAkcorB4vbASDfZQ3i6ASBfi78UpHLLz2fZOtY='
WHERE
key_id = '3a3fa36df5a019f9c68d1bd1097b9d6cd8e149537e401ccddf01d38105d8e970'
AND (
token = 'BXdKlwAkcorB4vbASDfZQ3i6ASBfi78UpHLLz2fZOtY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)