UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4lmw1gD5aBLDLknteu7LojMRZgClmLeEsJz08/04nU='
WHERE
key_id = 'caca0b3273df98ba82b9363d4ebbdef6c36c25614b940d9d3625c32bc274fa86'
AND (
token = 'a4lmw1gD5aBLDLknteu7LojMRZgClmLeEsJz08/04nU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)