UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Uf3L7AGYh0fyb2yawq8Myp/vIkz4KpaYhiYi3k1RvN0='
WHERE
key_id = 'e0a74de00fbbf2d9f2d7f34d149b66ced417a9720e3ccefd1bfec0f213a897ac'
AND (
token = 'Uf3L7AGYh0fyb2yawq8Myp/vIkz4KpaYhiYi3k1RvN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)