UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xaA9MCDw5fNShgMKOwQ8gNII7dyD5C2u+oMJTZxBcB4='
WHERE
key_id = 'cd17c43c4b66987c5ed713d55e94b80420a0051a9c45fa86ecfb60838c3b2af1'
AND (
token = 'xaA9MCDw5fNShgMKOwQ8gNII7dyD5C2u+oMJTZxBcB4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)