UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X/YZYZfGbcol6cquBU15E/WczTYGgDHoK7SWgPjowCA='
WHERE
key_id = 'bd581e7ba776bcfa9ff78881b76d7e6c13a0a58cb8a42e4651c1ebf4409d3991'
AND (
token = 'X/YZYZfGbcol6cquBU15E/WczTYGgDHoK7SWgPjowCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)