UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0W94at7xDsdXzbJcvRwratvn37yWP2vs+Dqk/KWrtAY='
WHERE
key_id = '1b67248fff901fd399617fbbca5ae7bff3b190be8d3fcc8efc172d63e2f8b500'
AND (
token = '0W94at7xDsdXzbJcvRwratvn37yWP2vs+Dqk/KWrtAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)