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