UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XoT7bDssmPN+ahPaeE6r796/MLS6SgvwpJPkytmFwqw='
WHERE
key_id = 'c80f7b869ac910ed4f8b5ccfebc26d576e4f66e43b1d1e9357b0d44747466661'
AND (
token = 'XoT7bDssmPN+ahPaeE6r796/MLS6SgvwpJPkytmFwqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)