UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wE3xUhmRmxPgpM9d82LIlVlOAKcvoi5JvaZjx6gyye4='
WHERE
key_id = '0ca02908305453d457885f224ee59b1696fd215be53170d842052ae0ba3b9f90'
AND (
token = 'wE3xUhmRmxPgpM9d82LIlVlOAKcvoi5JvaZjx6gyye4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)