UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'znlenYmiW8H8kMN25+dKlAKHiCYC4fW9k7l5p1ybqlg='
WHERE
key_id = 'd9b1ed9a7c7cc477c1353f0a8d1328d604228ca9b209c4fe08ff04b8fb9b2bc2'
AND (
token = 'znlenYmiW8H8kMN25+dKlAKHiCYC4fW9k7l5p1ybqlg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)