UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XFHdX9D1o5y5R3jw03TAgKeFHfYLY4jc/GjXqFO8gE='
WHERE
key_id = '9357b566db5f1952402e6229cfded8c8bf2ffe30b187f5fedb57982d6659030f'
AND (
token = '0XFHdX9D1o5y5R3jw03TAgKeFHfYLY4jc/GjXqFO8gE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)