UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vdWTU9jZQhOK52ulF4GRHARumSLwcKpwY0UGpf5q+DM='
WHERE
key_id = 'dfc146b14a847ef1da4727926f030e40455e93f016fb41e85f3db16ce5a6f9a0'
AND (
token = 'vdWTU9jZQhOK52ulF4GRHARumSLwcKpwY0UGpf5q+DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)