UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9Gv6JTUIaCBqsE5sWOxcjhzVRZB+wJx6fDV5m1GGhs='
WHERE
key_id = '8f643d8351f2337d73b58f889fcb22c7865e22aa2f83ca47a6305f548bca6e95'
AND (
token = 'L9Gv6JTUIaCBqsE5sWOxcjhzVRZB+wJx6fDV5m1GGhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)