UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zBtV7C08eQFyFxaM+PjneZvQ5K8OsDfgX6kt8jTp0/M='
WHERE
key_id = '195a9ca6ce3d7ba8b26090251ae9526e553626a41d24b18079259fbb868bcbc1'
AND (
token = 'zBtV7C08eQFyFxaM+PjneZvQ5K8OsDfgX6kt8jTp0/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)