UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gthHOlbdCzxNeOvW2+LBchlrnu/613MhXAEUJ2S4mYQ='
WHERE
key_id = '3fc1c770ca6a514a6f258e298c3b38f6d12f41fcbfbddaaaaccb643da280ca5a'
AND (
token = 'gthHOlbdCzxNeOvW2+LBchlrnu/613MhXAEUJ2S4mYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)