UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pU8XsBCMvewNH2y0LGbVBZasISeowJkOc7NYagnN6Kc='
WHERE
key_id = '8d8f870fea5a78803f8cc1c229c227425543a0d92d47608c519bd7eace9339e2'
AND (
token = 'pU8XsBCMvewNH2y0LGbVBZasISeowJkOc7NYagnN6Kc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)