UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4zN4273t6mXfxaH8O8JhEpWR001aXm45LZXH1sYSPZk='
WHERE
key_id = 'dac42eea0aa5b292ba486b6a5c9046aa6f77d201b4af094d83485f504e04549e'
AND (
token = '4zN4273t6mXfxaH8O8JhEpWR001aXm45LZXH1sYSPZk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)