UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hoJVpvCCSrhH3KBKFOHDZq46Bws47hotk/J6DpbcQp0='
WHERE
key_id = 'd4a3e7ac560ea40ce2fb356a54ce977d5d7f1fa9ac1e63f24892b4cb114ee245'
AND (
token = 'hoJVpvCCSrhH3KBKFOHDZq46Bws47hotk/J6DpbcQp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)