UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'csHC5Wrj2NZ3EgC7cUQGAfskiSB4RVgdsj6tzSOcF+4='
WHERE
key_id = '5f17ce1ad95f72ae3befee2b19aa925683dfa94ab8fbee4eb2b8734523eb9bab'
AND (
token = 'csHC5Wrj2NZ3EgC7cUQGAfskiSB4RVgdsj6tzSOcF+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)