UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQmKBtkK9NN01oDXYkqKGzqgiczsq33sJZsBXl5s9H0='
WHERE
key_id = '098a74a99599c786fca0c7de908481f57f8767362f656ae2350762a0dc3ea725'
AND (
token = 'pQmKBtkK9NN01oDXYkqKGzqgiczsq33sJZsBXl5s9H0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)