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