UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wGP9T9vEeVG15EvTkYHWy0PuTk/lrhtCUx2N1h2Z4O8='
WHERE
key_id = 'bae32c46267275227039d5923bf4109ad955d22f60d23972213ea1e6c3f2b94e'
AND (
token = 'wGP9T9vEeVG15EvTkYHWy0PuTk/lrhtCUx2N1h2Z4O8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)