UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZUFGVbHk1J/vL4K0oMkfVtcn+2+aT1pHVbHjb964Gdw='
WHERE
key_id = 'b4192495a0b8029aa41f8aae6b670e1db83d5ed2f1f3bd29c4efdefc67e56a10'
AND (
token = 'ZUFGVbHk1J/vL4K0oMkfVtcn+2+aT1pHVbHjb964Gdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)