UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGszDA4z1eFqzCr/TKWcy/Usk6mbcdR/xHtoZ2wu5OY='
WHERE
key_id = '9eb3b4a0b01457a8b8ec14a4a9cb5f5bc7f62c52ba383bec6d1f2b22a272a8d9'
AND (
token = 'HGszDA4z1eFqzCr/TKWcy/Usk6mbcdR/xHtoZ2wu5OY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)