UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cs6xJDeYBU2IaHLngAVI23P94l/VdD5Mpj5JrUDSWyY='
WHERE
key_id = 'db05050d860073f5f4b0952f0bb1d9669d64054f839f48bd22bb168e98b2155d'
AND (
token = 'cs6xJDeYBU2IaHLngAVI23P94l/VdD5Mpj5JrUDSWyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)