UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GUfW1kBSGZf9TjvEgaa1kKMZHkovIsHne0JQYBssawM='
WHERE
key_id = 'a32750f554c2c47d868f5ff10e12bbf5003fa6090b6f2724851427ca0de5575e'
AND (
token = 'GUfW1kBSGZf9TjvEgaa1kKMZHkovIsHne0JQYBssawM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)