UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IpWxBSsiZx3meB7BCwnKII8ZUo/9udUeoTEk4KJMvIM='
WHERE
key_id = 'aa0bdec172a2dc21d06f87227ffe112c610e627eeaa665022eb4abca14d9f7f2'
AND (
token = 'IpWxBSsiZx3meB7BCwnKII8ZUo/9udUeoTEk4KJMvIM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)