UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZP4eESS06jKYCl0WYC5YsLpD0j0yKPL/eYg2srbU9c='
WHERE
key_id = 'd1bef811acb61a841bb5dabe93e158a26cfa09de82f81628b62d7dc6484ca20c'
AND (
token = 'LZP4eESS06jKYCl0WYC5YsLpD0j0yKPL/eYg2srbU9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)