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